1. How to modify the Oracle user passwordwhen logging in as SYSDBA, you can modify other users ' passwords, such as: SQL> alter user name identified by new password; user changed. This is to change the USER01 user password to USER10If you want to
Oracle user unlock, oracle unlock
Connect first
SQL * Plus: Release 12.1.0.2.0 Production on Thursday February 12 15:40:422015
Copyright (c) 1982,201 4, Oracle. All rights reserved.
Enter the User name: system
Enter the password:
Last Successful
Part 1:Http://www.bkjia.com/Article/201208/151763.htmlRootPermission SecurityConfigurationSudoSudo is secure and reliable only after careful configuration. The sudo configuration file is/etc/sudoers. You can edit this file to grant specific users
Oracle user unlock
Connect first
SQL * Plus: Release 12.1.0.2.0 Production on Thursday February 12 15:40:422015
Copyright (c) 1982,201 4, Oracle. All rights reserved.
Enter the User name: system
Enter the password:
Last Successful Logon Time:
The problems encountered today are more interesting. First of all, the test database has not been opened for a long time, open today, using the service program testing, the following error message
for specific information, refer to the official forum information:
Http://wiki.ubuntu.org.cn/UbuntuSkills The user in item tenth is managed.
How Ubuntu modifies the current user name and adds the user to the Admin group--Let it have sudo
AlterUserHR account unlock;AlterUserHR identifiedByAdmin; -- Change Password
GrantSelectAnyTableToUser1 ;--
-- Use a user in Oracle to access tables of other users -- use HR to log on to the user with the permissions granted to the user.
1. Install the choice of automatic installation, forget the username and password led to now try a few Oracle default username password (the table with the default username and password), are prompted invalid username,
By default, Oracle has three users: sys password: custom; system password: custom; scott password: Tiger (locked by default). Note: to log on to the database as a Sys user, refer to [assysdba
By default, Oracle has three users: sys password: custom;
1. Start Sqlplus2. Please enter your username: Sqlplus/as sysdba3. Enter Password: direct return(Note: For SYS both lock and not lock can be locally certified log into SYSDBA)4. Connect to:Oracle Database 11g Enterprise Edition release
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.